﻿/*=================================================================
* 版权信息：Copyright (C) 2005-2011 捷点科技 All Rights Reserved.
* 文件名称：CNVP_UserLevel.cs
* 创建标识：曾乃强 15158756652 2011-03-18 01:03:05
* 修改标识：
* 功能描述：
===================================================================*/
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using CNVP.Framework.Helper;

namespace CNVP.JShop.BLL 
{
    /// <summary>
    /// 对*CNVP_UserLevel*操作(针对业务层)的实现
    /// </summary>
    public class CNVP_UserLevel
    {
        DAL.CNVP_UserLevel dal = new DAL.CNVP_UserLevel();
        
        #region BLL
        #region 添加
        /// <summary>
        /// 添加
        /// </summary>
        public int Add_CNVP_UserLevel(Model.CNVP_UserLevel obj)
        {
            return dal.Insert(obj);
        }
        #endregion
        
        #region 修改
        /// <summary>
        /// 修改
        /// </summary>
        public int Update_CNVP_UserLevel(Model.CNVP_UserLevel obj)
        {
            return dal.Update(obj);
        }
        #endregion
        
        #region 删除
        /// <summary>
        /// 删除
        /// </summary>
        public int Delete_CNVP_UserLevel(Model.CNVP_UserLevel obj)
        {
            return dal.Delete(obj);
        }
        
        /// <summary>
        /// 删除,生成列的主键列构成的参数列表
        /// </summary>
        public int Delete_CNVP_UserLevel(int ID)
        {
            return this.Delete_CNVP_UserLevel(new Model.CNVP_UserLevel() {
            
                 ID=ID
            });
        }
        #endregion 
        
        /// <summary>
        /// 查看单个
        /// </summary>
        public Model.CNVP_UserLevel GetSingle_CNVP_UserLevelById(int ID)
        {
            return dal.LoadById(ID);
        }
        /// <summary>
        /// 查看全部
        /// </summary>
        public List<Model.CNVP_UserLevel> GetAll_CNVP_UserLevel()
        {
            return dal.LoadAll();
        }
        #endregion

        public DataTable GetPage(string PageName, int PageIndex, int PageSize, out int RecordCount, out int PageCount, params SQLConditionInfo[] SqlCondition)
        {
            return dal.GetPage(PageName, PageIndex, PageSize, out RecordCount, out PageCount, SqlCondition);
        }

        /// <summary>
        /// 查看,sqlWhere
        /// </summary>
        public List<Model.CNVP_UserLevel> GetAll_CNVP_UserLevel(string sqlWhere)
        {
            return dal.LoadAll(sqlWhere);
        }

        public Model.CNVP_UserLevel LoadBysqlWhere(string sqlWhere)
        {
            return dal.LoadBysqlWhere(sqlWhere);
        }

        #region 设置默认时
        /// <summary>
        /// 把为‘1’全部更新设置成‘0’
        /// </summary>
        public int Update_CNVP_PostAddressWhereOne()
        {
            return dal.UpdateWhereOne();
        }
        #endregion

    }
}

